Unit XLSExportCSV5

DescriptionUsesClasses, Interfaces, Objects and RecordsFunctions and ProceduresTypesConstantsVariables

Description

 

Uses

Overview

Functions and Procedures

procedure ExportCSV(XLS: TXLSReadWriteII5; SheetIndex: integer; SeparatorChar, QuoteChar: WideChar; Options: TExportCSVOptions; Filename: AxUCString);

Types

TExportCSVOption = (...);
TExportCSVOptions = set of TExportCSVOption;

Description

Functions and Procedures

procedure ExportCSV(XLS: TXLSReadWriteII5; SheetIndex: integer; SeparatorChar, QuoteChar: WideChar; Options: TExportCSVOptions; Filename: AxUCString);

This routin will export the content of a worksheet to a text (CSV) file. ˜param XLS The XLSReadWriteII object to export. ˜param SheetIndex Index of the work sheet to export. ˜param QuoteChar Quote character for text strings. ˜param SeparatorChar The character used to separate the cell values (fields) in the file. Common used characters are comma, semicolon and tab. ˜param Options File export options. ˜param Filename The name of the file that the cells shall be exported to.

Types

TExportCSVOption = (...);

Options when exporting to CSV files.

Values
  • ecoQuotedStrings:  
  • ecoFormatValues: Put the content of string cells withing quotes.
  • ecoSelection: Apply number formatting to number cells. When not used, a number value is converted to a string with the FloatToStr function.
  • ecoFormulas: Export only the current selection. See ˜[link SheetData4.TSheet.SelectedAreas TSheet.SelectedAreas]. If there is more than one selected area, all of the will be written to the file.
TExportCSVOptions = set of TExportCSVOption;

Write the formulas to the file, instead of the values (result) of the formulas.


Generated by PasDoc 0.12.1 on 2013-03-18 12:36:48